Percona Xtrabackup 2.3.4 - Encryption and Compression performance

Setup

Backup duration

Backup duration by type, number of threads, and disk type, faceted by –parallel threads. The horizontal line on each graph shows the duration for the baseline (non compressed, non encrypted) backup.

plot of chunk global

Impact on throughput

The following graphs show tps for sysbench oltp (16 threads, 10M rows per table, 16 tables) while xtrabackup runs. Duration is not the same for all graphs as backups don't all last the same, which is why the faceting by –parallel threads produces graphs with varying width.

In all cases, the experiment was run as follows :

plot of chunk tpsplot of chunk tpsplot of chunk tpsplot of chunk tpsplot of chunk tpsplot of chunk tpsplot of chunk tpsplot of chunk tpsplot of chunk tpsplot of chunk tpsplot of chunk tpsplot of chunk tpsplot of chunk tpsplot of chunk tpsplot of chunk tps

Disk activity

The following graph shows disk busy percentage (as reported by pt-diskstats) per parallel threads, by backup type and threads. In all cases, ssd is the drive hosting MySQL's datadir, and hdd is the backup destination drive.

plot of chunk diskstatsplot of chunk diskstatsplot of chunk diskstats